USE [SIVN_OnlineTestingEngine]
GO
/****** Object:  ForeignKey [FK_Category_Category]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[Category] DROP CONSTRAINT [FK_Category_Category]
GO
/****** Object:  ForeignKey [FK_Question_Category]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[Question] DROP CONSTRAINT [FK_Question_Category]
GO
/****** Object:  ForeignKey [FK_Question_QuestionType]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[Question] DROP CONSTRAINT [FK_Question_QuestionType]
GO
/****** Object:  ForeignKey [FK_QuestionGroup_Category]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroup] DROP CONSTRAINT [FK_QuestionGroup_Category]
GO
/****** Object:  ForeignKey [FK_QuestionGroupCustomShare_QuestionGroupShareMode]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroupCustomShare] DROP CONSTRAINT [FK_QuestionGroupCustomShare_QuestionGroupShareMode]
GO
/****** Object:  ForeignKey [FK_QuestionGroupDetail_Question]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroupDetail] DROP CONSTRAINT [FK_QuestionGroupDetail_Question]
GO
/****** Object:  ForeignKey [FK_QuestionGroupDetail_QuestionGroup]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroupDetail] DROP CONSTRAINT [FK_QuestionGroupDetail_QuestionGroup]
GO
/****** Object:  ForeignKey [FK_QuestionGroupShareMode_QuestionGroup]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroupShareMode] DROP CONSTRAINT [FK_QuestionGroupShareMode_QuestionGroup]
GO
/****** Object:  ForeignKey [FK_QuestionGroupShareMode_ShareMode]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroupShareMode] DROP CONSTRAINT [FK_QuestionGroupShareMode_ShareMode]
GO
/****** Object:  ForeignKey [FK_UserCategory_Category]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[UserCategory] DROP CONSTRAINT [FK_UserCategory_Category]
GO
/****** Object:  Table [testing].[QuestionGroupCustomShare]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroupCustomShare] DROP CONSTRAINT [FK_QuestionGroupCustomShare_QuestionGroupShareMode]
GO
DROP TABLE [testing].[QuestionGroupCustomShare]
GO
/****** Object:  Table [testing].[QuestionGroupDetail]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroupDetail] DROP CONSTRAINT [FK_QuestionGroupDetail_Question]
GO
ALTER TABLE [testing].[QuestionGroupDetail] DROP CONSTRAINT [FK_QuestionGroupDetail_QuestionGroup]
GO
DROP TABLE [testing].[QuestionGroupDetail]
GO
/****** Object:  Table [testing].[QuestionGroupShareMode]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroupShareMode] DROP CONSTRAINT [FK_QuestionGroupShareMode_QuestionGroup]
GO
ALTER TABLE [testing].[QuestionGroupShareMode] DROP CONSTRAINT [FK_QuestionGroupShareMode_ShareMode]
GO
DROP TABLE [testing].[QuestionGroupShareMode]
GO
/****** Object:  Table [testing].[Question]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[Question] DROP CONSTRAINT [FK_Question_Category]
GO
ALTER TABLE [testing].[Question] DROP CONSTRAINT [FK_Question_QuestionType]
GO
DROP TABLE [testing].[Question]
GO
/****** Object:  Table [testing].[QuestionGroup]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroup] DROP CONSTRAINT [FK_QuestionGroup_Category]
GO
DROP TABLE [testing].[QuestionGroup]
GO
/****** Object:  Table [testing].[UserCategory]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[UserCategory] DROP CONSTRAINT [FK_UserCategory_Category]
GO
DROP TABLE [testing].[UserCategory]
GO
/****** Object:  Table [testing].[Category]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[Category] DROP CONSTRAINT [FK_Category_Category]
GO
DROP TABLE [testing].[Category]
GO
/****** Object:  Table [testing].[QuestionType]    Script Date: 06/11/2012 16:19:32 ******/
DROP TABLE [testing].[QuestionType]
GO
/****** Object:  Table [testing].[ShareMode]    Script Date: 06/11/2012 16:19:32 ******/
DROP TABLE [testing].[ShareMode]
GO
/****** Object:  Schema [testing]    Script Date: 06/11/2012 16:19:31 ******/
DROP SCHEMA [testing]
GO
/****** Object:  Schema [testing]    Script Date: 06/11/2012 16:19:31 ******/
CREATE SCHEMA [testing] AUTHORIZATION [dbo]
GO
/****** Object:  Table [testing].[ShareMode]    Script Date: 06/11/2012 16:19:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [testing].[ShareMode](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](200) NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](100) NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
	[ModifiedBy] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_ShareMode] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [testing].[QuestionType]    Script Date: 06/11/2012 16:19:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [testing].[QuestionType](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](100) NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](100) NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
	[ModifiedBy] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_QuestionType] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [testing].[Category]    Script Date: 06/11/2012 16:19:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [testing].[Category](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Parent] [int] NULL,
	[CreatedDate] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](100) NOT NULL,
	[ModifiedDate] [datetime] NULL,
	[ModifiedBy] [nvarchar](100) NULL,
	[Name] [nvarchar](100) NULL,
 CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [testing].[UserCategory]    Script Date: 06/11/2012 16:19:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [testing].[UserCategory](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[UserId] [int] NOT NULL,
	[CategoryId] [int] NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](100) NOT NULL,
	[ModifiedDate] [datetime] NULL,
	[ModifiedBy] [nvarchar](100) NULL,
 CONSTRAINT [PK_UserCategory] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [testing].[QuestionGroup]    Script Date: 06/11/2012 16:19:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [testing].[QuestionGroup](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](500) NOT NULL,
	[GroupId] [int] NULL,
	[UserId] [int] NULL,
	[CategoryId] [int] NOT NULL,
	[Time] [int] NOT NULL,
	[Image] [varchar](200) NULL,
	[CreatedDate] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](100) NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
	[ModifiedBy] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_QuestionGroup] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [testing].[Question]    Script Date: 06/11/2012 16:19:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [testing].[Question](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Content] [ntext] NOT NULL,
	[CategoryId] [int] NOT NULL,
	[UserId] [int] NOT NULL,
	[QuestionTypeId] [int] NOT NULL,
	[IsResult] [bit] NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](100) NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
	[ModifiedBy] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_Question] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [testing].[Answer]    Script Date: 06/12/2012 11:21:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [testing].[Answer](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[QuestionId] [int] NOT NULL,
	[Content] [ntext] NOT NULL,
	[IsResult] [bit] NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](100) NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
	[ModifiedBy] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_Answer] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE [testing].[Answer]  WITH CHECK ADD  CONSTRAINT [FK_Answer_Question] FOREIGN KEY([QuestionId])
REFERENCES [testing].[Question] ([Id])
GO

ALTER TABLE [testing].[Answer] CHECK CONSTRAINT [FK_Answer_Question]
GO

ALTER TABLE [testing].[Answer] ADD  CONSTRAINT [DF_Answer_IsResult]  DEFAULT ((0)) FOR [IsResult]
GO


/****** Object:  Table [testing].[QuestionGroupShareMode]    Script Date: 06/11/2012 16:19:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [testing].[QuestionGroupShareMode](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[QuestionGroup_Id] [int] NOT NULL,
	[ShareMode_Id] [int] NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](100) NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
	[ModifiedBy] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_QuestionGroupShareMode] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [testing].[QuestionGroupDetail]    Script Date: 06/11/2012 16:19:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [testing].[QuestionGroupDetail](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[QuestionGroupId] [int] NOT NULL,
	[QuestionId] [int] NOT NULL,
	[Mark] [float] NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](100) NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
	[ModifiedBy] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_QuestionGroupDetail] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [testing].[QuestionGroupCustomShare]    Script Date: 06/11/2012 16:19:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [testing].[QuestionGroupCustomShare](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[QuestionGroupShareMode_Id] [int] NOT NULL,
	[User_Id] [int] NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](100) NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
	[ModifiedBy] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_QuestionGroupCustomShare] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  ForeignKey [FK_Category_Category]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[Category]  WITH CHECK ADD  CONSTRAINT [FK_Category_Category] FOREIGN KEY([Id])
REFERENCES [testing].[Category] ([Id])
GO
ALTER TABLE [testing].[Category] CHECK CONSTRAINT [FK_Category_Category]
GO
/****** Object:  ForeignKey [FK_Question_Category]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[Question]  WITH CHECK ADD  CONSTRAINT [FK_Question_Category] FOREIGN KEY([CategoryId])
REFERENCES [testing].[Category] ([Id])
GO
ALTER TABLE [testing].[Question] CHECK CONSTRAINT [FK_Question_Category]
GO
/****** Object:  ForeignKey [FK_Question_QuestionType]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[Question]  WITH CHECK ADD  CONSTRAINT [FK_Question_QuestionType] FOREIGN KEY([QuestionTypeId])
REFERENCES [testing].[QuestionType] ([Id])
GO
ALTER TABLE [testing].[Question] CHECK CONSTRAINT [FK_Question_QuestionType]
GO
/****** Object:  ForeignKey [FK_QuestionGroup_Category]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroup]  WITH CHECK ADD  CONSTRAINT [FK_QuestionGroup_Category] FOREIGN KEY([CategoryId])
REFERENCES [testing].[Category] ([Id])
GO
ALTER TABLE [testing].[QuestionGroup] CHECK CONSTRAINT [FK_QuestionGroup_Category]
GO
/****** Object:  ForeignKey [FK_QuestionGroupCustomShare_QuestionGroupShareMode]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroupCustomShare]  WITH CHECK ADD  CONSTRAINT [FK_QuestionGroupCustomShare_QuestionGroupShareMode] FOREIGN KEY([QuestionGroupShareMode_Id])
REFERENCES [testing].[QuestionGroupShareMode] ([Id])
GO
ALTER TABLE [testing].[QuestionGroupCustomShare] CHECK CONSTRAINT [FK_QuestionGroupCustomShare_QuestionGroupShareMode]
GO
/****** Object:  ForeignKey [FK_QuestionGroupDetail_Question]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroupDetail]  WITH CHECK ADD  CONSTRAINT [FK_QuestionGroupDetail_Question] FOREIGN KEY([QuestionId])
REFERENCES [testing].[Question] ([Id])
GO
ALTER TABLE [testing].[QuestionGroupDetail] CHECK CONSTRAINT [FK_QuestionGroupDetail_Question]
GO
/****** Object:  ForeignKey [FK_QuestionGroupDetail_QuestionGroup]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroupDetail]  WITH CHECK ADD  CONSTRAINT [FK_QuestionGroupDetail_QuestionGroup] FOREIGN KEY([QuestionGroupId])
REFERENCES [testing].[QuestionGroup] ([Id])
GO
ALTER TABLE [testing].[QuestionGroupDetail] CHECK CONSTRAINT [FK_QuestionGroupDetail_QuestionGroup]
GO
/****** Object:  ForeignKey [FK_QuestionGroupShareMode_QuestionGroup]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroupShareMode]  WITH CHECK ADD  CONSTRAINT [FK_QuestionGroupShareMode_QuestionGroup] FOREIGN KEY([QuestionGroup_Id])
REFERENCES [testing].[QuestionGroup] ([Id])
GO
ALTER TABLE [testing].[QuestionGroupShareMode] CHECK CONSTRAINT [FK_QuestionGroupShareMode_QuestionGroup]
GO
/****** Object:  ForeignKey [FK_QuestionGroupShareMode_ShareMode]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[QuestionGroupShareMode]  WITH CHECK ADD  CONSTRAINT [FK_QuestionGroupShareMode_ShareMode] FOREIGN KEY([ShareMode_Id])
REFERENCES [testing].[ShareMode] ([Id])
GO
ALTER TABLE [testing].[QuestionGroupShareMode] CHECK CONSTRAINT [FK_QuestionGroupShareMode_ShareMode]
GO
/****** Object:  ForeignKey [FK_UserCategory_Category]    Script Date: 06/11/2012 16:19:32 ******/
ALTER TABLE [testing].[UserCategory]  WITH CHECK ADD  CONSTRAINT [FK_UserCategory_Category] FOREIGN KEY([Category_Id])
REFERENCES [testing].[Category] ([Id])
GO
ALTER TABLE [testing].[UserCategory] CHECK CONSTRAINT [FK_UserCategory_Category]
GO

USE [SIVN_OnlineTestingEngine]
GO

/****** Object:  Table [testing].[Like]    Script Date: 06/18/2012 11:02:09 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [testing].[Like](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[IsDislike] [bit] NOT NULL,
	[QuestionId] [int] NOT NULL,
	[QuestionGroupId] [int] NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](100) NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
	[ModifiedBy] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_Like] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [testing].[Like] ADD  CONSTRAINT [DF_Like_IsDislike]  DEFAULT ((0)) FOR [IsDislike]
GO

/****** Object:  Table [testing].[Comment]    Script Date: 06/18/2012 11:07:43 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [testing].[Comment](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Content] [nvarchar](1000) NOT NULL,
	[QuestionId] [int] NULL,
	[QuestionGroupId] [int] NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](100) NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
	[ModifiedBy] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_Comment] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

